Create Line and Clustered Chart for Total Accidents by Time 15

Now let us create our third chart with is a Line and clustered chart for Total Accidents by Time. Please follow detailed steps below to achieve the same results.



Step 1: In the visualization pane, select the Line and stacked column chart. In the 'MyMeasures' Table, click 'AccidentsPerDay' and 'HighSeverityPerDay' as Column values. Drag and drop %YOYHighSeverity and %YOYAccidentsPerDay into the Line values. Drag and drop %HighSeverity to the Tooltips. In the Time table, click on 'Hour Extended' to add to Shared axis. (See screenshot below)



Step 2: Format Chart using the guide below 

I. General


II. X axis and Y axis



III. Data colors


IV. Data labels, Shapes, Background, and Shadow



V. Title



Step 3: Now we need to sort the Hour extended in order. To do this, click on the ellipses (more options) on the chart. Click on Sort ascending. Go to 'Sort by; then click on 'Hours Extended'. (See GIF below)



Step 4: Save your report 'Ctrl + S'

Create and use combo chart in Power BI Desktop: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-combo-chart